package com.mingda.weathermagiccenter.mapper;

import com.mingda.weathermagiccenter.pojo.SdtProject;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author Administrator
* @description 针对表【sdt_project】的数据库操作Mapper
*/
@Mapper
public interface SdtProjectMapper extends BaseMapper<SdtProject>
{
    @Select({ "<script>",
        "SELECT id, name, area_data, charge_man, phone, status, parent_id, platform, ",
        "f1, f2, f3, f4, f5, cuser, uuser, ctime, utime, flag,area_data_cn,org_type ",
        " FROM sdt_project where flag = '1' and f1 is not null",
    "</script>" })
    public List<Map<String, Object>> getSdtProjectList();
}
